package com.ysd.ziyuanshiyongtongji.dao;

import com.ysd.ziyuanshiyongtongji.model.Member;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

/**
 * IMemberDao
 */
public interface IMemberDao extends JpaRepository<Member,Integer>,JpaSpecificationExecutor<Member>{

    //根据卡号查询状态
    @Query("select m from Member m where m.cardNo = :cardNo")
    Member getCardStatus(String cardNo);
}